﻿<%@ Page Language="vb" AutoEventWireup="false" MasterPageFile="~/main.Master" CodeBehind="List.aspx.vb" Inherits="moviesblogspot.List" 
    title="List" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder2" runat="server">
    
   
    
    <table style="width: 100%">
        <tr>
            <td style="width: 354px; height: 244px;">
                <br />
                <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
                    DataSourceID="SqlDataSource2" CellPadding="4" ForeColor="#333333" 
                    GridLines="None">
                    <AlternatingRowStyle BackColor="White" />
                    <Columns>
                        <asp:BoundField DataField="moviename" HeaderText="INPRODUCTIONMOVIES" />
                    </Columns>
                    <FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
                    <HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
                    <PagerStyle BackColor="#FFCC66" ForeColor="#333333" HorizontalAlign="Center" />
                    <RowStyle BackColor="#FFFBD6" ForeColor="#333333" />
                    <SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="Navy" />
                    <SortedAscendingCellStyle BackColor="#FDF5AC" />
                    <SortedAscendingHeaderStyle BackColor="#4D0000" />
                    <SortedDescendingCellStyle BackColor="#FCF6C0" />
                    <SortedDescendingHeaderStyle BackColor="#820000" />
                </asp:GridView>
                <asp:SqlDataSource ID="SqlDataSource2" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:MovieConnectionString %>" 
                    ProviderName="<%$ ConnectionStrings:MovieConnectionString.ProviderName %>" 
                    
                    SelectCommand="SELECT [id],[Status], [MovieName] FROM [Inprod] WHERE ([Status] = 1)">
                </asp:SqlDataSource>
            </td>
            
                   <td align="center" style="height: 244px">
                        <h3>List of Movies</h3>
                             <asp:HyperLink ID="HyperLink1"  runat="server" 
         NavigateUrl="~/Rss.aspx" CssClass="rsshyp" Font-Size="Large">MoviesBlog RSS</asp:HyperLink>
    <img alt="RssImage" src="Images/rss_icon.jpg" style=" height:20px; width: 20px; vertical-align:bottom;" />
     <br />
                        </td>
        </tr>
        <tr>
            <td style="width: 354px">
                <asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False" 
                    DataSourceID="SqlDataSource1" CellPadding="4" ForeColor="#333333" 
                    GridLines="None">
                    <AlternatingRowStyle BackColor="White" />
                    <Columns>
                        <asp:BoundField DataField="moviename" HeaderText="FORTHCOMINGMOVIES" />
                    </Columns>
                    <FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
                    <HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
                    <PagerStyle BackColor="#FFCC66" ForeColor="#333333" HorizontalAlign="Center" />
                    <RowStyle BackColor="#FFFBD6" ForeColor="#333333" />
                    <SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="Navy" />
                    <SortedAscendingCellStyle BackColor="#FDF5AC" />
                    <SortedAscendingHeaderStyle BackColor="#4D0000" />
                    <SortedDescendingCellStyle BackColor="#FCF6C0" />
                    <SortedDescendingHeaderStyle BackColor="#820000" />
                </asp:GridView>
                <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:MovieConnectionString %>" 
                    ProviderName="<%$ ConnectionStrings:MovieConnectionString.ProviderName %>" 
                    
                    SelectCommand="SELECT [id],[Status], [MovieName] FROM [Inprod] WHERE ([Status] = 2)">
                </asp:SqlDataSource>
                <br />
                <br />
            </td>
            <td>
              <asp:GridView ID="GridView3" runat="server" AutoGenerateColumns="False" 
            DataKeyNames="movieID" DataSourceID="bollySqlDataSource" CssClass="gridclass">
            <Columns>
                <asp:BoundField DataField="movieID" HeaderText="movieID" InsertVisible="False" 
                    ReadOnly="True" SortExpression="movieID" />
                <asp:BoundField DataField="moviename" HeaderText="moviename" 
                    SortExpression="moviename" />
                <asp:BoundField DataField="ratings" HeaderText="ratings" 
                    SortExpression="ratings" />
                <asp:BoundField DataField="categories_id" HeaderText="categories_id" 
                    SortExpression="categories_id" />
                <asp:ImageField DataImageUrlField="image" HeaderText="Movieimage">
                </asp:ImageField>
                <asp:HyperLinkField DataNavigateUrlFields="movieID" 
                    DataNavigateUrlFormatString="Details.aspx?movieID={0}" HeaderText="Details" 
                    Text="MoreDetails" />
            </Columns>
        </asp:GridView>
        <asp:SqlDataSource ID="bollySqlDataSource" runat="server" 
            ConnectionString="<%$ ConnectionStrings:MovieConnectionString %>" 
            ProviderName="<%$ ConnectionStrings:MovieConnectionString.ProviderName %>" 
            SelectCommand="SELECT [movieID], [moviename], [ratings], [categories_id], [image] FROM [movies]">
        </asp:SqlDataSource>
                &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
                &nbsp;</td>
        </tr>
    </table>
    
   
    
    </asp:Content>
